Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
PartyID (FK)(PK) | A unique, system assigned identity for a Party. | ID_PRTY | Identity | integer | |
LegalStatusCode (FK) | A code that indicates the ORGANIZATION's legal or tax status. For example, this may be Commercial Corporation, Not-for-profit, Non-profit, Academic, Government, etc. | CD_LGL_STS | Code | varchar(20) | LegalStatusType(LU_LGL_STS) |
LegalName | The name used by an organization for legal purposes. Usually designates the formal name of an organization that conducts business under a different "doin business as" or trade name. Different alias for the same party. | NM_LGL | Name | varchar(40) | |
TradeName | The name underwhich this organization conducts its business. It may different from its LegalName. | NM_TRD | Name | varchar(40) | |
TerminationDate | Date this organization ceased to operate and was closed for business. | DC_TRMN | ExpirationDate | date | |
JurisdictionOfIncorporation | The name of the territory, state, province or other political subdivision that authorized the incorporation of the Organization. | NM_JRDT_OF_INCRP | DescriptionShort | varchar(255) | |
IncorporationDate | Date this Organization was legally incorporated. This is different from the StartUpDate. Incorporation may occurr before or after a StartUpDate. | DC_INCRP | DateCalendar | date | |
LegalOrganizationTypeCode (FK) | Defines the type of legal organization the Organization is using to conduct business. The code values will vary by country and JurisdictionOfIncorporation. Here are some examples: SOLE_PROPRIETOR PARTNERSHIP LIMITED_PARTNERSHIP S-CORPORATION C-CORPORATION LIMITED_LIAB_COMPANY OTHER | CD_LGL_ORGN_TYP | Code | varchar(20) | LegalOrganizationType(LU_LGL_ORGN) |
FiscalYearEndDate | The date (month and day) this organizations fiscal year ends on. Note that for certain kinds of businesses this can accelerate buying as managers seek to use or lose their spendable budgets. | DC_FSC_YR_END | DateCalendar | date | |
BusinessActivityCode (FK) | A code that identifies the primary type of business the Organzation is engaged in. The coding schema varies from country to country. In the US the UC Census NAICS codes are used. This may be used to indicate the categories of merchandise a given Organization is likely to purchase. | CD_BSN_ACTV | Code | varchar(20) | BusinessActivityReference(LU_BSN_ACTV_RFC) |
LocalAnnualRevenueAmount | Total revenue earned by the organization in the "local" market. Local as used here means the country or next level political subdivison. It' primary use is to distinguish sales volume of a local part of a global or national company from the over all aggregated revenue. | MO_LCL_ANN_RVN | Money | decimal(16,5) | |
GlobalAnnualRevenueAmount | The total revenue for a global or national company. | MO_GBL_ANN_RVN | Money | decimal(16,5) | |
OpenForBusinessDate | The date the Organization opened. | DC_OPN_FR_BSN | DateCalendar | date | |
ClosedForBusinessDate | The date the Organization ceased operating. | DC_CLSD_FR_BSN | DateCalendar | date | |
DUNSNumber | The D&B D-U-N-S Number is a non-indicative, nine-digit number assigned to each business location in the D&B database having a unique, separate, and distinct operation, and is maintained solely by D&B. The D&B D-U-N-S Number is used by industries and organizations around the world as a global standard for business identification and tracking. If you don`t have a D-U-N-S Number, you can get one for free through the SBS site. | ID_DUNS_NBR | IdentityDunsIdentifier | char(9) | |
BankruptcyFlag | A boolean indicator that tell if this Organization has ever experienced bankruptcy or not. This indicator is set to true even if the organization is NOT CURRENTLY bankrupt but has experience bankruptcy in its past. | FL_BNKRPTY | Flag | integer | |
BankruptcyDate | The date the organization declared bankruptcy | DC_BNKRPTY | DateCalendar | date | |
BankruptcyEmergenceDate | The date the Organization emerged from bankruptcy | DC_BNKRPTY_EMRGNC | DateCalendar | date | |
BankruptcyTypeCode | A retailer defined code that tells what kind of bankruptcy proceeding the Organization went through. Examples based on US bankruptcy laws include: CHAPTER_7 - Liquidation CHAPTER_9 - Municipal Bankrupcty (applies only to public bodies) CHAPTER 11 - Reorganization under bankruptcy code CHAPTER 12 - Family Farmer Bankruptcy or family Fisherman Bankruptcy CHAPTER 13 - Individual debit adjustment (applicable to sole proprietors and partners) CHAPTER 15 - Ancillary and other cross Border cases | CD_BNKRPTY_TYP | Code | varchar(20) | |
EmployeeCountLocal | Number of employees locally (in the country, state or municipality). The intepretation of "local" is up to the retailer based on their approach to defining market areas. | QU_EM_CNT_LCL | QuantityInteger | integer | |
EmployeeCountGlobal | Total number of employees for the Organization as a whole. | QU_EM_CNT_GBL | QuantityInteger | integer | |
DunnAndBradstreetRating | A code that indicates the size and credit worthiness of the Organization. The code value is determined by Dunn and Bradstreet. | CD_RTG_DUNN_AND_BRDST | Code | varchar(20) | |
PrimaryBusiness (FK) | A combination of ISO-639-1 and ISO-3661-1 to denote a lanuage as spoken in a particular country. | ID_LGE_PRMRY | Code4External | char(4) | Language(CO_LGE) |
OrganizationDescriptionNarrative | Short narrative description of the organization to capture retailer defined unstructured information about an organization. | NA_DE_ORGN | DescriptionNarrative | varchar(4000) | |
GlobalBusinessSizeTypeCode (FK) | A code that designates the relative GLOBAL size of an Organization. | CD_GBL_BSN_TYP | Code | varchar(20) | GlobalBusinessSizeType(LU_GBL_BSN_TYP) |
ReligionName (FK) | Name of religion sect within a religion family. 1 Abrahamic religions 1.1 Babism 1.2 Bah�'� Faith 1.3 Christianity 1.3.1 Other groups 1.4 Druze 1.5 Gnosticism 1.6 Islam 1.7 Judaism 1.8 Rastafari movement 1.9 Mandaeans and Sabians 1.10 Samaritanism 1.11 Shabakism 2 Indian religions 2.1 Ayyavazhi 2.2 Bhakti movement 2.3 Buddhism 2.4 Din-i-Ilahi 2.5 Hinduism 2.6 Jainism 2.7 Meivazhi 2.8 Sikhism 3 Iranian religions 3.1 Manichaeism 3.2 Mazdakism 3.3 Mithraism 3.4 Yazd�nism 3.5 Zoroastrianism 4 East Asian religions 4.1 Confucianism 4.2 Shinto 4.3 Taoism 4.4 Other 5 African diasporic religions 6 Indigenous traditional religions 6.1 African 6.2 American 6.3 Eurasian 6.4 Oceania/Pacific 6.4.1 Cargo cults 7 Historical polytheism 7.1 Ancient Near Eastern 7.2 Indo-European 7.3 Hellenistic 8 Mysticism and Occult 8.1 Esotericism and mysticism 8.2 Occult and magic 9 Neopaganism 9.1 Syncretic 9.2 Ethnic 10 New religious movements 10.1 Creativity 10.2 New Thought 10.3 Shinshukyo 11 Left-hand path religions 12 Fictional religions 13 Parody or mock religions 14 Others | NM_RLGN | Code | varchar(20) | ReligionType(LU_RLGN_TYP) |
ReligionFamilyCode (FK) | Abrahamic religions 2 Indian religions 3 Iranian religions 4 East Asian religions 5 African diasporic religions 6 Indigenous traditional religions 7 Historical polytheism 8 Mysticism and Occult 9 Neopaganism 10 New religious movements 11 Left-hand path religions 12 Fictional religions 13 Parody or mock religions 14 Others | CD_RLGN_FMY | Code | varchar(20) | ReligionType(LU_RLGN_TYP) |